package com.cn.mobileproject.db.table;

import android.provider.BaseColumns;

public class UserTable  implements  BaseColumns {
	
	public static final String TABLE_NAME = "t_user";
	public static final String FIELD_UID="uid";
	public static final String FIELD_ACCOUNT="account";
	public static final String FIELD_PASSWORD="password";
	
	public static final String FIELD_ORGID="orgid";
	public static final String FIELD_ORGNAME="orgname";
	public static final String FIELD_USERNAME="username";
	public static final String FIELD_TIME="time";

	
	public static final String[] TABLE_COLUMNS = new String[] { 
		 _ID,
	     FIELD_UID,
	     FIELD_ACCOUNT,
	     FIELD_PASSWORD,
	     FIELD_ORGID,
	     FIELD_ORGNAME,
	     FIELD_TIME,
	     FIELD_USERNAME
	};

	public static final String CREATE_TABLE = "create table "
        + TABLE_NAME + " (" 
        	+ FIELD_UID + " text not null ,"
        	+ FIELD_ACCOUNT + " text ,"
        	+ FIELD_PASSWORD + " text ,"
        	+ FIELD_ORGID + " text ,"
        	+ FIELD_ORGNAME + " text ,"
        	+ FIELD_USERNAME + " text ,"
        	+ FIELD_TIME + " long ,"
        	+ " constraint pk_t2 primary key ("
	    	+ FIELD_UID	    	
	    	+ ")"
	    	+ ")";
	
}
